Step 1: Open the project in Visual Studio.
Step 2: Add a Crystal Report by right clicking on the project in the Solution Explorer and selecting Add -> Add New Item -> Crystal Report. Give any name for the report.
Step 3: From the Crystal Reports Gallery, select Using the Report Wizard.
Step 4: In the Standard Report Creation wizard, select Create New Connection->OLE DB (ADO).
Step 5: Click OLE DB (ADO) item to launch OLE DB Provider dialog to select data source.
Step 6: In OLE DB Provider, select Microsoft OLE DB Provider for SQL Server (assuming SQL Server is accessible) and click Next.
Step 7: Provide the connection information about a data source and click Finish.
Step 8: In the Standard Report Creation wizard, added database will be shown and expanding the database item will show underlying tables.
Step 9: Select a table from the list and click Next.
Step 10: On this page, select the fields that needed in the report and click Finish.
|